Effective dating
Snapshots
Automation
User friendly interface
Many cunyfirst tables don’t have effective dates
Almost no tables in CUNY first have end dates
Many cunyfirst tables don’t have effective dates
Almost no tables in CUNY first have end dates
The data warehouse daily scans our CUNY First data, finds changes in records, and creates effective dates/end dates
Historical static views of CUNY First at specified points in history
Census dates, first day of term, current offset
IT has this all set up automatically
The reporting instance query
Extraction from tumbleweed
The effective dating
The snapshots
OBIEE web app interface
Abstracts away leftover complexity of datawarehouse
No SQL required
Drag and drop gui